﻿set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


CREATE PROCEDURE [dbo].[sp_GetUserDataByEmail]
    @Email				NVARCHAR(256)
AS
BEGIN

	SELECT	 m.[UserId]
			,u.[UserName]
			,m.[Email]
	FROM		[dbo].[aspnet_Membership] m inner join
				[dbo].[aspnet_Users] u ON m.[UserId] = u.[UserId]
	WHERE		m.[LoweredEmail] = LOWER(@Email) 

END

